Formula 13

Operators/Functions Used

ToText, Truncate, Division (/), Concatenate (+), Remainder

Formula Purpose

Bulk grains and nuts are inventoried by the ounce, but management wants to see a breakdown in pounds and ounces on the inventory report.

Formula

ToText((Truncate({file.OZ}/16)),0) + " pounds, " +
ToText((Remainder ({file.OZ}, 16)),0) + " ounces "

Result

Ounces Resulting Text

433

"27 pounds, 1 ounces"

278

"17 pounds, 6 ounces"

1455

"90 pounds, 15 ounces"

Explanation

Related topics

Formulas in action



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com